/*
 Navicat Premium Data Transfer

 Source Server         : demo
 Source Server Type    : MySQL
 Source Server Version : 80031
 Source Host           : localhost:3306
 Source Schema         : day17-monthtestA

 Target Server Type    : MySQL
 Target Server Version : 80031
 File Encoding         : 65001

 Date: 29/12/2022 20:12:52
*/


-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT '学生姓名',
  `group` varchar(255) DEFAULT NULL COMMENT '小组',
  `age` int DEFAULT NULL COMMENT '年龄',
  `score` int DEFAULT NULL COMMENT '成绩',
  `birthday` date DEFAULT NULL COMMENT '生日',
  `city_id` int DEFAULT NULL COMMENT '城市id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of student
-- ----------------------------
BEGIN;
INSERT INTO `student` (`id`, `name`, `group`, `age`, `score`, `birthday`, `city_id`) VALUES (1, '张涛', '1', 20, 15, '2022-12-01', 1);
INSERT INTO `student` (`id`, `name`, `group`, `age`, `score`, `birthday`, `city_id`) VALUES (2, '孟玉明', '1', 19, 0, '2022-12-02', 2);
INSERT INTO `student` (`id`, `name`, `group`, `age`, `score`, `birthday`, `city_id`) VALUES (3, '田晓枫', '2', 21, 0, '2022-12-03', 3);
INSERT INTO `student` (`id`, `name`, `group`, `age`, `score`, `birthday`, `city_id`) VALUES (4, '徐昱', '2', 21, 15, '2022-12-05', 4);
INSERT INTO `student` (`id`, `name`, `group`, `age`, `score`, `birthday`, `city_id`) VALUES (5, '高林海', '3', 20, 0, '2022-12-06', 5);
INSERT INTO `student` (`id`, `name`, `group`, `age`, `score`, `birthday`, `city_id`) VALUES (6, '张帅航', '3', 20, 100, '2022-12-07', 1);
INSERT INTO `student` (`id`, `name`, `group`, `age`, `score`, `birthday`, `city_id`) VALUES (7, '刘嘉奇', '4', 21, 0, '2022-12-08', 3);
INSERT INTO `student` (`id`, `name`, `group`, `age`, `score`, `birthday`, `city_id`) VALUES (8, '李坤钰', '4', 20, 15, '2022-12-09', 2);
INSERT INTO `student` (`id`, `name`, `group`, `age`, `score`, `birthday`, `city_id`) VALUES (9, '张耿宁', '5', 20, 50, '2022-12-10', 3);
INSERT INTO `student` (`id`, `name`, `group`, `age`, `score`, `birthday`, `city_id`) VALUES (10, '张高立', '5', 21, 90, '2022-12-29', 2);
INSERT INTO `student` (`id`, `name`, `group`, `age`, `score`, `birthday`, `city_id`) VALUES (11, '赵子超', '6', 20, 90, '2022-12-15', 4);
INSERT INTO `student` (`id`, `name`, `group`, `age`, `score`, `birthday`, `city_id`) VALUES (12, '李鑫文', '6', 20, 90, '2022-12-16', 5);
INSERT INTO `student` (`id`, `name`, `group`, `age`, `score`, `birthday`, `city_id`) VALUES (13, '张旭', '7', 18, 15, '2022-12-06', 1);
INSERT INTO `student` (`id`, `name`, `group`, `age`, `score`, `birthday`, `city_id`) VALUES (14, '李鑫亮', '7', 18, 0, '2022-12-08', 3);
INSERT INTO `student` (`id`, `name`, `group`, `age`, `score`, `birthday`, `city_id`) VALUES (15, '崔舜', '7', 18, 85, '2022-12-10', 1);
INSERT INTO `student` (`id`, `name`, `group`, `age`, `score`, `birthday`, `city_id`) VALUES (16, '苗君鑫', '7', 19, 100, '2022-12-11', 2);
INSERT INTO `student` (`id`, `name`, `group`, `age`, `score`, `birthday`, `city_id`) VALUES (17, '范晓虎', '7', 20, 15, '2022-12-10', 1);
INSERT INTO `student` (`id`, `name`, `group`, `age`, `score`, `birthday`, `city_id`) VALUES (18, '崔小强', '7', 20, 25, '2022-12-27', 5);
COMMIT;

